SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE [dbo].[paCertificaObtenerNiveles] 
-- < Registro de Actualizaciones >
-- 25-10-2006 
-- 23-11-2006
-- 11-12-2006

	@IdSubProyecto INT 

AS
SET NOCOUNT ON
SELECT NE.idNivelEnsenanza AS ID, NE.NivelEnsenanza AS Descripcion
	FROM tb_NivelesEnsenanza NE
	WHERE NE.IdNivelEnsenanza NOT IN (SELECT   NSP.IdNivel FROM Tb_RelNivelesSP NSP  WHERE  NSP.IdSubProyecto=@IdSubProyecto)
	ORDER BY NE.NivelEnsenanza
GO
GRANT EXECUTE ON  [dbo].[paCertificaObtenerNiveles] TO [Certificaciones]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerNiveles] TO [CertificacionesAdministracion]
GRANT EXECUTE ON  [dbo].[paCertificaObtenerNiveles] TO [SoloVer]
GO
